﻿CREATE TABLE [dbo].[tb_inout]
(
	inout_id bigint identity(1,1) primary key,
	inout_code nvarchar(20) not null,
	inout_level nvarchar(20) not null,
	inout_customer nvarchar(20) not null,
	inout_location nvarchar(20) not null,
	inout_in decimal(5,1) not null,
	inout_out decimal(5,1) not null,
	inout_date smalldatetime not null,
	inout_agent nvarchar(20) not null,
	inout_car nvarchar(20) not null,
	inout_ncust nvarchar(20) default('') not null,
	inout_ncode nvarchar(20) default('') not null,
	inout_nloca nvarchar(20) default('') not null,
	inout_check nvarchar(20) default('') not null,
	inout_number nvarchar(20) default('') not null,
	inout_memo nvarchar(255) default('') not null,
	inout_oman nvarchar(20) not null,
	inout_otime smalldatetime not null
);